In VBA, a variable name is not case sensitive.  Implicit Declaration means that variables are used without declaring them. It is a...

1. Implicit Declaration means that variables are used without declaring them.

2. It is a good practice to declare all the variables you want to use.

3. The variables StudentGrade and STUDENTGRADE represent different variables.

4. Dim answer As Integer
   Declares the variable answer of type double

1. Range("A1").Value

2. Cells(1, 1).Value

Refers to the contents of cell A1 in Excel sheet 1

Refers to the contents of cell B1 in Excel sheet 1

Page 1 of 5

11. Const PI = 3.14159

EET 1003
In the above declaration, PI is declared as a constant

1. LCase() and UCase are example of string functions in VBA.

2. Perimeter = 2 / Radius
   In the above expression, Perimeter and Radius are of type double. If Radius=4, then the value of Perimeter is 1.5

3. The function MsgBox() is used to output user data .

4. The function InputBox() is used to collect user input data.

5. The value 3.1456 is an example of Type Integer in VBA.